---
title: DB-CLL-006 — Retrieve case cost list for a legal case
summary: Retrieve case cost list for a legal case
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-006 — Retrieve case cost list for a legal case

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-006 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsCaseCostCollection |
| Criteria property | MyRetrieveSQL |
| Lifecycle method | BeforeRetrieve |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier used to filter the cost list |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [CASE_COST](../database-tables.md#case_cost) | SELECT | LEGAL_CASE_SEQ_NUM, all CASE_COST columns |

## Sample SQL

```sql
Select
  CASE_COST.CASE_COST_SEQ_NUM as CaseCostID,
  CASE_COST.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  CASE_COST.PAYEE_FIRM_PROV_LOC_ID as PayeeFirmProvLocID,
  CASE_COST.PAYEE_PERSON_PROV_LOC_ID as PayeePersonProvLocID,
  CASE_COST.SERVICE_FROM_DATE as ServiceFromDate,
  CASE_COST.SERVICE_TO_DATE as ServiceTODate,
  CASE_COST.SERVICE_CODE as ServiceCode,
  CASE_COST.AMOUNT_PAID as AmountPaid,
  CASE_COST.AUTHORIZER_EMPLID as AuthorizerEmplid,
  CASE_COST.AUTHORIZED_DATE as AuthorizedDate,
  CASE_COST.AMOUNT_BILLED as AmountBilled,
  CASE_COST.PREPAYMENT_FLAG as PrepaymentFlag,
  CASE_COST.CANCELLED_BY_CODE as CancelledBYCode,
  CASE_COST.CREATE_DATE as CreateDate,
  CASE_COST.CREATE_USER as CreateUser,
  CASE_COST.UPDATE_DATE as UpdateDate,
  CASE_COST.UPDATE_USER as UpdateUser,
  CASE_COST.AMOUNT_PER_HOUR as AmountPerHour,
  CASE_COST.HOURS_BILLED as HoursBilled
From
  CASE_COST
Where
  CASE_COST.LEGAL_CASE_SEQ_NUM = :LegalCaseID
Order by
  CASE_COST.SERVICE_FROM_DATE desc
```

## Operations and processes

- [Manage case cost entries](../operations/manage-case-cost.md)

## Business rules

- [BR-CLM-LGL-001](../business-rules.md#br-clm-lgl-001-case-cost-date-ranges-must-be-valid)
- [BR-CLM-LGL-002](../business-rules.md#br-clm-lgl-002-case-cost-entry-requires-a-payee)
- [BR-CLM-LGL-003](../business-rules.md#br-clm-lgl-003-case-cost-entry-requires-service-code%2C-authorizer%2C-and-canceller)
- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb`